package com.ztesoft.web.baseconfig.db.arg;

import java.util.*;
import java.math.*;
import org.apache.commons.lang.*;

public class SubTableDefineArg {
    private String pk_name = "DATA_ID";

    private String orderByClause;

    private String groupByClause;

    private String columns;

    private String countsql1;

    private String countsql2;

    private boolean distinct;

    private int rowStart = 0;

    private int rowEnd = 10;

    private List<SubTableDefineCriteria> oredCriteria;

    public SubTableDefineArg() {
        oredCriteria = new ArrayList<SubTableDefineCriteria>();
    }

    public void setPk_name(String pk_name) {
        this.pk_name = StringEscapeUtils.escapeSql(pk_name);
    }

    public String getPk_name() {
        return pk_name;
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = StringEscapeUtils.escapeSql(orderByClause);
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = StringEscapeUtils.escapeSql(groupByClause);
    }

    public String geGroupByClause() {
        return groupByClause;
    }

    public void setColumns(String columns) {
        this.columns = StringEscapeUtils.escapeSql(columns);
    }

    public String geColumns() {
        return columns;
    }

    public void setCountsql1(String countsql1) {
        this.countsql1 = StringEscapeUtils.escapeSql(countsql1);
    }

    public String geCountsql1() {
        return countsql1;
    }

    public void setCountsql2(String countsql2) {
        this.countsql2 = StringEscapeUtils.escapeSql(countsql2);
    }

    public String geCountsql2() {
        return countsql2;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public void setRowStart(int rowStart) {
        this.rowStart = rowStart;
    }

    public void setRowEnd(int rowEnd) {
        this.rowEnd = rowEnd;
    }

    public int getRowStart() {
        return rowStart;
    }

    public int getRowEnd() {
        return rowEnd;
    }

    public List<SubTableDefineCriteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(SubTableDefineCriteria criteria) {
        oredCriteria.add(criteria);
    }

    public SubTableDefineCriteria or() {
    	SubTableDefineCriteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public SubTableDefineCriteria createCriteria() {
    	SubTableDefineCriteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected SubTableDefineCriteria createCriteriaInternal() {
    	SubTableDefineCriteria criteria = new SubTableDefineCriteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        groupByClause = null;
        columns = null;
        countsql1 = null;
        countsql2 = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<SubTableDefineCriterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<SubTableDefineCriterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<SubTableDefineCriterion> getAllCriteria() {
            return criteria;
        }

        public List<SubTableDefineCriterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new SubTableDefineCriterion(condition));
        }

        protected void addCriterion(String condition, Object value,
                String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new SubTableDefineCriterion(condition, value));
        }

        protected void addCriterion(String condition, Object value,
                String property, int likeType) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new SubTableDefineCriterion(condition, value, likeType));
        }

        protected void addCriterion(String condition, Object value1,
                Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property
                        + " cannot be null");
            }
            criteria.add(new SubTableDefineCriterion(condition, value1, value2));
        }

        public SubTableDefineCriteria andCriterionEqualTo(String criterion) {
            if (StringUtils.isBlank(criterion)) {
                criterion = "1=1";
            }
            addCriterion(criterion);
            return (SubTableDefineCriteria) this;
        }
        public SubTableDefineCriteria andDataIdIsNull() {
            addCriterion("DATA_ID is null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdIsNotNull() {
            addCriterion("DATA_ID is not null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdEqualTo(Integer value) {
            addCriterion("DATA_ID =", value, "DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdNotEqualTo(Integer value) {
            addCriterion("DATA_ID <>", value, "DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdGreaterThan(Integer value) {
            addCriterion("DATA_ID >", value, "DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("DATA_ID >=", value, "DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdLessThan(Integer value) {
            addCriterion("DATA_ID <", value, "DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdLessThanOrEqualTo(Integer value) {
            addCriterion("DATA_ID <=", value, "DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdLike(Integer value) {
            addCriterion("DATA_ID like ", value, "DATA_ID", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdNotLike(Integer value) {
            addCriterion("DATA_ID  not like ", value, "DATA_ID", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdLeftLike(Integer value) {
            addCriterion("DATA_ID like ", value, "DATA_ID", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdNotLeftLike(Integer value) {
            addCriterion("DATA_ID  not like ", value, "DATA_ID", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdRightLike(Integer value) {
            addCriterion("DATA_ID like ", value, "DATA_ID", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdNotRightLike(Integer value) {
            addCriterion("DATA_ID  not like ", value, "DATA_ID", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdIn(List<Integer> values) {
            addCriterion("DATA_ID  in ", values, "DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdNotIn(List<Integer> values) {
            addCriterion("DATA_ID not in ", values, "DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdBetween(Integer value1, Integer value2) {
            addCriterion("DATA_ID between ", value1, value2, "DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataIdNotBetween(Integer value1, Integer value2) {
            addCriterion("DATA_ID not between ", value1, value2, "DATA_ID");
            return (SubTableDefineCriteria) this;
        }
        public SubTableDefineCriteria andSeqNbrIsNull() {
            addCriterion("SEQ_NBR is null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrIsNotNull() {
            addCriterion("SEQ_NBR is not null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrEqualTo(Integer value) {
            addCriterion("SEQ_NBR =", value, "SEQ_NBR");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrNotEqualTo(Integer value) {
            addCriterion("SEQ_NBR <>", value, "SEQ_NBR");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrGreaterThan(Integer value) {
            addCriterion("SEQ_NBR >", value, "SEQ_NBR");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrGreaterThanOrEqualTo(Integer value) {
            addCriterion("SEQ_NBR >=", value, "SEQ_NBR");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrLessThan(Integer value) {
            addCriterion("SEQ_NBR <", value, "SEQ_NBR");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrLessThanOrEqualTo(Integer value) {
            addCriterion("SEQ_NBR <=", value, "SEQ_NBR");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrLike(Integer value) {
            addCriterion("SEQ_NBR like ", value, "SEQ_NBR", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrNotLike(Integer value) {
            addCriterion("SEQ_NBR  not like ", value, "SEQ_NBR", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrLeftLike(Integer value) {
            addCriterion("SEQ_NBR like ", value, "SEQ_NBR", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrNotLeftLike(Integer value) {
            addCriterion("SEQ_NBR  not like ", value, "SEQ_NBR", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrRightLike(Integer value) {
            addCriterion("SEQ_NBR like ", value, "SEQ_NBR", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrNotRightLike(Integer value) {
            addCriterion("SEQ_NBR  not like ", value, "SEQ_NBR", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrIn(List<Integer> values) {
            addCriterion("SEQ_NBR  in ", values, "SEQ_NBR");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrNotIn(List<Integer> values) {
            addCriterion("SEQ_NBR not in ", values, "SEQ_NBR");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrBetween(Integer value1, Integer value2) {
            addCriterion("SEQ_NBR between ", value1, value2, "SEQ_NBR");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSeqNbrNotBetween(Integer value1, Integer value2) {
            addCriterion("SEQ_NBR not between ", value1, value2, "SEQ_NBR");
            return (SubTableDefineCriteria) this;
        }
        public SubTableDefineCriteria andDataTypeIsNull() {
            addCriterion("DATA_TYPE is null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeIsNotNull() {
            addCriterion("DATA_TYPE is not null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeEqualTo(Integer value) {
            addCriterion("DATA_TYPE =", value, "DATA_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeNotEqualTo(Integer value) {
            addCriterion("DATA_TYPE <>", value, "DATA_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeGreaterThan(Integer value) {
            addCriterion("DATA_TYPE >", value, "DATA_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("DATA_TYPE >=", value, "DATA_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeLessThan(Integer value) {
            addCriterion("DATA_TYPE <", value, "DATA_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeLessThanOrEqualTo(Integer value) {
            addCriterion("DATA_TYPE <=", value, "DATA_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeLike(Integer value) {
            addCriterion("DATA_TYPE like ", value, "DATA_TYPE", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeNotLike(Integer value) {
            addCriterion("DATA_TYPE  not like ", value, "DATA_TYPE", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeLeftLike(Integer value) {
            addCriterion("DATA_TYPE like ", value, "DATA_TYPE", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeNotLeftLike(Integer value) {
            addCriterion("DATA_TYPE  not like ", value, "DATA_TYPE", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeRightLike(Integer value) {
            addCriterion("DATA_TYPE like ", value, "DATA_TYPE", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeNotRightLike(Integer value) {
            addCriterion("DATA_TYPE  not like ", value, "DATA_TYPE", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeIn(List<Integer> values) {
            addCriterion("DATA_TYPE  in ", values, "DATA_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeNotIn(List<Integer> values) {
            addCriterion("DATA_TYPE not in ", values, "DATA_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeBetween(Integer value1, Integer value2) {
            addCriterion("DATA_TYPE between ", value1, value2, "DATA_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andDataTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("DATA_TYPE not between ", value1, value2, "DATA_TYPE");
            return (SubTableDefineCriteria) this;
        }
        public SubTableDefineCriteria andPriorityIsNull() {
            addCriterion("PRIORITY is null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityIsNotNull() {
            addCriterion("PRIORITY is not null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityEqualTo(Integer value) {
            addCriterion("PRIORITY =", value, "PRIORITY");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityNotEqualTo(Integer value) {
            addCriterion("PRIORITY <>", value, "PRIORITY");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityGreaterThan(Integer value) {
            addCriterion("PRIORITY >", value, "PRIORITY");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityGreaterThanOrEqualTo(Integer value) {
            addCriterion("PRIORITY >=", value, "PRIORITY");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityLessThan(Integer value) {
            addCriterion("PRIORITY <", value, "PRIORITY");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityLessThanOrEqualTo(Integer value) {
            addCriterion("PRIORITY <=", value, "PRIORITY");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityLike(Integer value) {
            addCriterion("PRIORITY like ", value, "PRIORITY", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityNotLike(Integer value) {
            addCriterion("PRIORITY  not like ", value, "PRIORITY", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityLeftLike(Integer value) {
            addCriterion("PRIORITY like ", value, "PRIORITY", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityNotLeftLike(Integer value) {
            addCriterion("PRIORITY  not like ", value, "PRIORITY", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityRightLike(Integer value) {
            addCriterion("PRIORITY like ", value, "PRIORITY", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityNotRightLike(Integer value) {
            addCriterion("PRIORITY  not like ", value, "PRIORITY", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityIn(List<Integer> values) {
            addCriterion("PRIORITY  in ", values, "PRIORITY");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityNotIn(List<Integer> values) {
            addCriterion("PRIORITY not in ", values, "PRIORITY");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityBetween(Integer value1, Integer value2) {
            addCriterion("PRIORITY between ", value1, value2, "PRIORITY");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andPriorityNotBetween(Integer value1, Integer value2) {
            addCriterion("PRIORITY not between ", value1, value2, "PRIORITY");
            return (SubTableDefineCriteria) this;
        }
        public SubTableDefineCriteria andSubDefineTypeIsNull() {
            addCriterion("SUB_DEFINE_TYPE is null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeIsNotNull() {
            addCriterion("SUB_DEFINE_TYPE is not null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeEqualTo(Integer value) {
            addCriterion("SUB_DEFINE_TYPE =", value, "SUB_DEFINE_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeNotEqualTo(Integer value) {
            addCriterion("SUB_DEFINE_TYPE <>", value, "SUB_DEFINE_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeGreaterThan(Integer value) {
            addCriterion("SUB_DEFINE_TYPE >", value, "SUB_DEFINE_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("SUB_DEFINE_TYPE >=", value, "SUB_DEFINE_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeLessThan(Integer value) {
            addCriterion("SUB_DEFINE_TYPE <", value, "SUB_DEFINE_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeLessThanOrEqualTo(Integer value) {
            addCriterion("SUB_DEFINE_TYPE <=", value, "SUB_DEFINE_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeLike(Integer value) {
            addCriterion("SUB_DEFINE_TYPE like ", value, "SUB_DEFINE_TYPE", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeNotLike(Integer value) {
            addCriterion("SUB_DEFINE_TYPE  not like ", value, "SUB_DEFINE_TYPE", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeLeftLike(Integer value) {
            addCriterion("SUB_DEFINE_TYPE like ", value, "SUB_DEFINE_TYPE", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeNotLeftLike(Integer value) {
            addCriterion("SUB_DEFINE_TYPE  not like ", value, "SUB_DEFINE_TYPE", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeRightLike(Integer value) {
            addCriterion("SUB_DEFINE_TYPE like ", value, "SUB_DEFINE_TYPE", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeNotRightLike(Integer value) {
            addCriterion("SUB_DEFINE_TYPE  not like ", value, "SUB_DEFINE_TYPE", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeIn(List<Integer> values) {
            addCriterion("SUB_DEFINE_TYPE  in ", values, "SUB_DEFINE_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeNotIn(List<Integer> values) {
            addCriterion("SUB_DEFINE_TYPE not in ", values, "SUB_DEFINE_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeBetween(Integer value1, Integer value2) {
            addCriterion("SUB_DEFINE_TYPE between ", value1, value2, "SUB_DEFINE_TYPE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("SUB_DEFINE_TYPE not between ", value1, value2, "SUB_DEFINE_TYPE");
            return (SubTableDefineCriteria) this;
        }
        public SubTableDefineCriteria andSubDefineValueIsNull() {
            addCriterion("SUB_DEFINE_VALUE is null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueIsNotNull() {
            addCriterion("SUB_DEFINE_VALUE is not null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueEqualTo(String value) {
            addCriterion("SUB_DEFINE_VALUE =", value, "SUB_DEFINE_VALUE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueNotEqualTo(String value) {
            addCriterion("SUB_DEFINE_VALUE <>", value, "SUB_DEFINE_VALUE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueGreaterThan(String value) {
            addCriterion("SUB_DEFINE_VALUE >", value, "SUB_DEFINE_VALUE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueGreaterThanOrEqualTo(String value) {
            addCriterion("SUB_DEFINE_VALUE >=", value, "SUB_DEFINE_VALUE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueLessThan(String value) {
            addCriterion("SUB_DEFINE_VALUE <", value, "SUB_DEFINE_VALUE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueLessThanOrEqualTo(String value) {
            addCriterion("SUB_DEFINE_VALUE <=", value, "SUB_DEFINE_VALUE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueLike(String value) {
            addCriterion("SUB_DEFINE_VALUE like ", value, "SUB_DEFINE_VALUE", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueNotLike(String value) {
            addCriterion("SUB_DEFINE_VALUE  not like ", value, "SUB_DEFINE_VALUE", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueLeftLike(String value) {
            addCriterion("SUB_DEFINE_VALUE like ", value, "SUB_DEFINE_VALUE", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueNotLeftLike(String value) {
            addCriterion("SUB_DEFINE_VALUE  not like ", value, "SUB_DEFINE_VALUE", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueRightLike(String value) {
            addCriterion("SUB_DEFINE_VALUE like ", value, "SUB_DEFINE_VALUE", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueNotRightLike(String value) {
            addCriterion("SUB_DEFINE_VALUE  not like ", value, "SUB_DEFINE_VALUE", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueIn(List<String> values) {
            addCriterion("SUB_DEFINE_VALUE  in ", values, "SUB_DEFINE_VALUE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueNotIn(List<String> values) {
            addCriterion("SUB_DEFINE_VALUE not in ", values, "SUB_DEFINE_VALUE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueBetween(String value1, String value2) {
            addCriterion("SUB_DEFINE_VALUE between ", value1, value2, "SUB_DEFINE_VALUE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubDefineValueNotBetween(String value1, String value2) {
            addCriterion("SUB_DEFINE_VALUE not between ", value1, value2, "SUB_DEFINE_VALUE");
            return (SubTableDefineCriteria) this;
        }
        public SubTableDefineCriteria andSourceDataIdIsNull() {
            addCriterion("SOURCE_DATA_ID is null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdIsNotNull() {
            addCriterion("SOURCE_DATA_ID is not null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID =", value, "SOURCE_DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdNotEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID <>", value, "SOURCE_DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdGreaterThan(Integer value) {
            addCriterion("SOURCE_DATA_ID >", value, "SOURCE_DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID >=", value, "SOURCE_DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdLessThan(Integer value) {
            addCriterion("SOURCE_DATA_ID <", value, "SOURCE_DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdLessThanOrEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID <=", value, "SOURCE_DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdLike(Integer value) {
            addCriterion("SOURCE_DATA_ID like ", value, "SOURCE_DATA_ID", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdNotLike(Integer value) {
            addCriterion("SOURCE_DATA_ID  not like ", value, "SOURCE_DATA_ID", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdLeftLike(Integer value) {
            addCriterion("SOURCE_DATA_ID like ", value, "SOURCE_DATA_ID", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdNotLeftLike(Integer value) {
            addCriterion("SOURCE_DATA_ID  not like ", value, "SOURCE_DATA_ID", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdRightLike(Integer value) {
            addCriterion("SOURCE_DATA_ID like ", value, "SOURCE_DATA_ID", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdNotRightLike(Integer value) {
            addCriterion("SOURCE_DATA_ID  not like ", value, "SOURCE_DATA_ID", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdIn(List<Integer> values) {
            addCriterion("SOURCE_DATA_ID  in ", values, "SOURCE_DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdNotIn(List<Integer> values) {
            addCriterion("SOURCE_DATA_ID not in ", values, "SOURCE_DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdBetween(Integer value1, Integer value2) {
            addCriterion("SOURCE_DATA_ID between ", value1, value2, "SOURCE_DATA_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSourceDataIdNotBetween(Integer value1, Integer value2) {
            addCriterion("SOURCE_DATA_ID not between ", value1, value2, "SOURCE_DATA_ID");
            return (SubTableDefineCriteria) this;
        }
        public SubTableDefineCriteria andSubRefColIsNull() {
            addCriterion("SUB_REF_COL is null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColIsNotNull() {
            addCriterion("SUB_REF_COL is not null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColEqualTo(String value) {
            addCriterion("SUB_REF_COL =", value, "SUB_REF_COL");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColNotEqualTo(String value) {
            addCriterion("SUB_REF_COL <>", value, "SUB_REF_COL");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColGreaterThan(String value) {
            addCriterion("SUB_REF_COL >", value, "SUB_REF_COL");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColGreaterThanOrEqualTo(String value) {
            addCriterion("SUB_REF_COL >=", value, "SUB_REF_COL");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColLessThan(String value) {
            addCriterion("SUB_REF_COL <", value, "SUB_REF_COL");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColLessThanOrEqualTo(String value) {
            addCriterion("SUB_REF_COL <=", value, "SUB_REF_COL");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColLike(String value) {
            addCriterion("SUB_REF_COL like ", value, "SUB_REF_COL", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColNotLike(String value) {
            addCriterion("SUB_REF_COL  not like ", value, "SUB_REF_COL", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColLeftLike(String value) {
            addCriterion("SUB_REF_COL like ", value, "SUB_REF_COL", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColNotLeftLike(String value) {
            addCriterion("SUB_REF_COL  not like ", value, "SUB_REF_COL", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColRightLike(String value) {
            addCriterion("SUB_REF_COL like ", value, "SUB_REF_COL", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColNotRightLike(String value) {
            addCriterion("SUB_REF_COL  not like ", value, "SUB_REF_COL", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColIn(List<String> values) {
            addCriterion("SUB_REF_COL  in ", values, "SUB_REF_COL");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColNotIn(List<String> values) {
            addCriterion("SUB_REF_COL not in ", values, "SUB_REF_COL");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColBetween(String value1, String value2) {
            addCriterion("SUB_REF_COL between ", value1, value2, "SUB_REF_COL");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andSubRefColNotBetween(String value1, String value2) {
            addCriterion("SUB_REF_COL not between ", value1, value2, "SUB_REF_COL");
            return (SubTableDefineCriteria) this;
        }
        public SubTableDefineCriteria andStaffIdIsNull() {
            addCriterion("STAFF_ID is null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdIsNotNull() {
            addCriterion("STAFF_ID is not null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdEqualTo(Integer value) {
            addCriterion("STAFF_ID =", value, "STAFF_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdNotEqualTo(Integer value) {
            addCriterion("STAFF_ID <>", value, "STAFF_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdGreaterThan(Integer value) {
            addCriterion("STAFF_ID >", value, "STAFF_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("STAFF_ID >=", value, "STAFF_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdLessThan(Integer value) {
            addCriterion("STAFF_ID <", value, "STAFF_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdLessThanOrEqualTo(Integer value) {
            addCriterion("STAFF_ID <=", value, "STAFF_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdLike(Integer value) {
            addCriterion("STAFF_ID like ", value, "STAFF_ID", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdNotLike(Integer value) {
            addCriterion("STAFF_ID  not like ", value, "STAFF_ID", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdLeftLike(Integer value) {
            addCriterion("STAFF_ID like ", value, "STAFF_ID", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdNotLeftLike(Integer value) {
            addCriterion("STAFF_ID  not like ", value, "STAFF_ID", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdRightLike(Integer value) {
            addCriterion("STAFF_ID like ", value, "STAFF_ID", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdNotRightLike(Integer value) {
            addCriterion("STAFF_ID  not like ", value, "STAFF_ID", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdIn(List<Integer> values) {
            addCriterion("STAFF_ID  in ", values, "STAFF_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdNotIn(List<Integer> values) {
            addCriterion("STAFF_ID not in ", values, "STAFF_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdBetween(Integer value1, Integer value2) {
            addCriterion("STAFF_ID between ", value1, value2, "STAFF_ID");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStaffIdNotBetween(Integer value1, Integer value2) {
            addCriterion("STAFF_ID not between ", value1, value2, "STAFF_ID");
            return (SubTableDefineCriteria) this;
        }
        public SubTableDefineCriteria andStateIsNull() {
            addCriterion("STATE is null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "STATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "STATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "STATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "STATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "STATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "STATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateLike(String value) {
            addCriterion("STATE like ", value, "STATE", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateNotLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateLeftLike(String value) {
            addCriterion("STATE like ", value, "STATE", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateNotLeftLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateRightLike(String value) {
            addCriterion("STATE like ", value, "STATE", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateNotRightLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateIn(List<String> values) {
            addCriterion("STATE  in ", values, "STATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in ", values, "STATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between ", value1, value2, "STATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between ", value1, value2, "STATE");
            return (SubTableDefineCriteria) this;
        }
        public SubTableDefineCriteria andStateDateIsNull() {
            addCriterion("STATE_DATE is null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateIsNotNull() {
            addCriterion("STATE_DATE is not null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateEqualTo(String value) {
            addCriterion("STATE_DATE =", value, "STATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateNotEqualTo(String value) {
            addCriterion("STATE_DATE <>", value, "STATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateGreaterThan(String value) {
            addCriterion("STATE_DATE >", value, "STATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE_DATE >=", value, "STATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateLessThan(String value) {
            addCriterion("STATE_DATE <", value, "STATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateLessThanOrEqualTo(String value) {
            addCriterion("STATE_DATE <=", value, "STATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateNotLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateLeftLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateNotLeftLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateRightLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateNotRightLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateIn(List<String> values) {
            addCriterion("STATE_DATE  in ", values, "STATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateNotIn(List<String> values) {
            addCriterion("STATE_DATE not in ", values, "STATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateBetween(String value1, String value2) {
            addCriterion("STATE_DATE between ", value1, value2, "STATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andStateDateNotBetween(String value1, String value2) {
            addCriterion("STATE_DATE not between ", value1, value2, "STATE_DATE");
            return (SubTableDefineCriteria) this;
        }
        public SubTableDefineCriteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateEqualTo(String value) {
            addCriterion("CREATE_DATE =", value, "CREATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateNotEqualTo(String value) {
            addCriterion("CREATE_DATE <>", value, "CREATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateGreaterThan(String value) {
            addCriterion("CREATE_DATE >", value, "CREATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_DATE >=", value, "CREATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateLessThan(String value) {
            addCriterion("CREATE_DATE <", value, "CREATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateLessThanOrEqualTo(String value) {
            addCriterion("CREATE_DATE <=", value, "CREATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateNotLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 1);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateLeftLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateNotLeftLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 0);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateRightLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateNotRightLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 2);
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateIn(List<String> values) {
            addCriterion("CREATE_DATE  in ", values, "CREATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateNotIn(List<String> values) {
            addCriterion("CREATE_DATE not in ", values, "CREATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateBetween(String value1, String value2) {
            addCriterion("CREATE_DATE between ", value1, value2, "CREATE_DATE");
            return (SubTableDefineCriteria) this;
        }

        public SubTableDefineCriteria andCreateDateNotBetween(String value1, String value2) {
            addCriterion("CREATE_DATE not between ", value1, value2, "CREATE_DATE");
            return (SubTableDefineCriteria) this;
        }

    }

    public static class SubTableDefineCriteria extends GeneratedCriteria {

        protected SubTableDefineCriteria() {
            super();
        }
    }

    public static class SubTableDefineCriterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected SubTableDefineCriterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }
        protected SubTableDefineCriterion(String condition, Object value, int likeType) {
            this.condition = condition;
            if (likeType == 0) {
                this.value = "%" + value;
            }
            else if (likeType == 1) {
                this.value = "%" + value + "%";
            }
            else {
                this.value = value + "%";
            }
            this.typeHandler = null;
            this.singleValue = true;

        }

        protected SubTableDefineCriterion(String condition, Object value,
                String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            }
            else {
                this.singleValue = true;
            }
        }

        protected SubTableDefineCriterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected SubTableDefineCriterion(String condition, Object value,
                Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected SubTableDefineCriterion(String condition, Object value,
                Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}